package org.jeecg.modules.yw.mapper;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.yw.entity.FlPrice;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

@Mapper
public interface FlPriceMapper extends BaseMapper<FlPrice> {
	/**
	 * 
	 * @param enterpriseId
	 * @return
	 */
    @Select("SELECT * from fl_price_enterprise where enterpriseId=#{enterpriseId}")
    public FlPrice getAllInfoByEnterpriseId(@Param("enterpriseId") String enterpriseId);
    
    
    
    
    
    @Insert("INSERT INTO fl_price_enterprise (hflPrice,qtjhflPrice,qtjbhflPrice,nbljhflPrice,wbljhflPrice,nqtjhflPrice,nbljbhflPrice,wbljbhflPrice,nqtjbhflPrice,dqnbljhflPrice,dqwbljhflPrice,dqnqtjhflPrice,dqnbljbhflPrice,dqwbljbhflPrice,dqnqtjbhflPrice,gbdkPrice,gfccPrice,cpbyPrice,wgscPrice,sghjPrice,enterpriseId) "
    		+ "VALUES(#{hflPrice},#{qtjhflPrice},#{qtjbhflPrice},#{nbljhflPrice},#{wbljhflPrice},#{nqtjhflPrice},#{nbljbhflPrice},#{wbljbhflPrice},#{nqtjbhflPrice},#{dqnbljhflPrice},#{dqwbljhflPrice},#{dqnqtjhflPrice},#{dqnbljbhflPrice},#{dqwbljbhflPrice},#{dqnqtjbhflPrice},#{gbdkPrice},#{gfccPrice},#{cpbyPrice},#{wgscPrice},#{sghjPrice},#{enterpriseId})")
    public int inserFPrice(FlPrice flPrice);
    
    
	/**
	 * 
	 * @param enterpriseId
	 * @return
	 */
    @Delete("delete from fl_price_enterprise where enterpriseId=#{enterpriseId}")
    public int deleteByEnterpriseId(@Param("enterpriseId") String enterpriseId);
}
